if exists (select name from sysobjects where name like 'Proc_TaiKhoanTC_GetById')
	drop procedure Proc_TaiKhoanTC_GetById
go

create PROC Proc_TaiKhoanTC_GetById (@maTKThe int )
as
	select * from TaiKhoanTC
	where @maTKThe= TaiKhoanTC.MaTKTheChap
go

Exec Proc_TaiKhoanTC_GetById 1
go
--------------------------------------
if exists (select name from sysobjects where name like 'Proc_TaiKhoanTC_GetByMaTKVay')
	drop procedure Proc_TaiKhoanTC_GetByMaTKVay
go

create PROC Proc_TaiKhoanTC_GetByMaTKVay (@maTKVay nvarchar )
as
	select * from TaiKhoanTC
	where @maTKVay= TaiKhoanTC.MaTKVay
go
--------------------------------------------
if exists (select name from sysobjects where name like 'Proc_TaiKhoanTC_GetByMaLoaiTK')
	drop procedure Proc_TaiKhoanTC_GetByMaLoaiTK
go

create PROC Proc_TaiKhoanTC_GetByMaLoaiTK (@maLoaiTK nvarchar )
as
	select * from TaiKhoanTC
	where @maLoaiTK= TaiKhoanTC.MaLoaiTK
go